This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
RE: NotesSQL Error - The driver doesn't support the version of ODBC behavior that the application requested. ~Judy Desfreevitch 15.Jan.04 01:25 PM a Web browser General All ReleasesAll Platforms
Unfortunately, the ASP.Net's ODBC bridge is giving the error, not NotesSQL. What the error means is that you (or ASP.Net's ODBC bridge) are trying to perform a command that didn't exist or was not applicable for the version of the ODBC driver you specified. NotesSQL is a 2.x driver, current ODBC spec is up to 3.5x. Normally, the ODBC Manager handles the conversion between versions, but not on all functions...
Anyway, If nothing got logged with Tracing on, you may have to set some registry entries and reboot for them to take effect. Please see the following (taken from a previous post I made):
... You could also enable ODBC Tracing to see if things are failing. Unfortunately for services (like IIS), you can't enable it throught the ODBC Data Source Administrator. You must change/create some registry entries and then reboot. Here's what needs to be changed/created:
in the HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ODBC hive, change or
create the following String Values and set it to the value listed:
Trace = 1
TraceFile = C:\SQL.LOG (or whatever you want to call it)
Be sure to set Trace to 0 or delete
the registry keys and reboot when done or else ODBC will be extremely slow
and the log file will eat up tremendous amounts of hard drive space.
You should be able to look at the resulting LOG file to see where it is failing (at least which ODBC calls are failing).